On the Use of Dimension Properties in Heterogeneous Data Warehouse Integration
نویسندگان
چکیده
A new trend in Business Intelligence is the process of combining information from two or more different and heterogeneous Data Warehouses. Existing solutions rely mostly on the Extract-Transform-Load (ETL) approach, a costly and laborious process. The process of Data Warehouse integration can be greatly simplified by developing methods to semi-automatically discover semantic mappings among attributes of two or more different, heterogeneous Data Warehouse schemas, like the one proposed in this paper.
منابع مشابه
Semi-automatic Discovery of Mappings Between Heterogeneous Data Warehouse Dimensions
Data Warehousing is the main Business Intelligence instrument for the analysis of large amounts of data. It permits the extraction of relevant information for decision making processes inside organizations. Given the great diffusion of Data Warehouses, there is an increasing need to integrate information coming from independent Data Warehouses or from independently developed data marts in the s...
متن کاملInvestigating a heterogeneous data integration approach for data warehousing
Data warehouses integrate data from remote, heterogeneous, autonomous data sources into a materialised central database. The heterogeneity of these data sources has two aspects, data expressed in different data models, called model heterogeneity, and data expressed within different schemas of the same data model, called schema heterogeneity. AutoMed is an approach to heterogeneous data transfor...
متن کاملData Warehouse Design Methods Review for the Healthcare Domain
This paper presents current research trends and ongoing challenges in data warehouse design methods. In secondary data use context, traditional data warehouse design methods don’t address many of today’s challenges; particularly in the healthcare domain were semantics plays an essential role to achieve an effective and implementable heterogeneous data integration while satisfying core requireme...
متن کاملA relational-XML data warehouse for data aggregation with SQL and XQuery
Integration of multiple data sources is becoming increasingly important for enterprises that cooperate closely with their partners for e-commerce. OLAP enables analysts and decision makers fast access to various materialized views from data warehouses. However, many corporations have internal business applications deployed on different platforms. No standard solution for integration exists, exc...
متن کامل3D and 4D Seismic Data Integration in Static and Dynamic Reservoir Modeling: A Review
Reservoir modeling is the process of generating numerical representations of reservoir conditions and properties on the basis of geological, geophysical, and engineering data measured on the Earth’s surface or in depth at a limited number of borehole locations. Therefore, reservoir modeling requires an incorporation of the data from a variety of sources, along with an integration of knowledge a...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2012